'use strict'

const pg = require('pg');

let psql = new pg.Pool({
    database: 'liujing',
    user: 'liujing',
    port: 5432,
    host: '127.0.0.1',
    password: '222222',
    //最大使用5个客户端连接
    max: 5
})

    ; (async () => {
        let tm = Date.now()
        //随机数字转成16进制并去掉前两位
        let id = `${Math.random().toString(16).substring(2)}`

        let sqltext = `INSERT INTO`
            + ` content(id, detail,title,add_time,update_time)`
            + `VALUES($1,$2,$3,$4,$5)`;
        let r = await psql.query(sqltext, [
            id,   `测试内容：${Math.random()}`, 'test',
            tm, tm
        ])
        console.log(r)
        //关闭连接
        psql.end()
}) ();
